﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$ForumDBConnection$" type="$ForumDBType$" defaultFormatter="bizobj ForumThread(lastPostBy,createdBy)">
  <SqlStatement hasResults="true">
    SELECT
    id, title, forumId, totalPosts, dateCreated, threadImageUrl,
    createdById, createdByName as createdByuserName,
    lastPostById, lastPostByName as lastPostByuserName
    FROM ForumThreads
    WHERE forumId=@forumId
  </SqlStatement>
  <Param name="forumId" type="UniqueIdentifier" />
</DbDataRequest>